package com.example.gss.mapper;

import com.example.gss.entity.CourseScore;
import org.apache.ibatis.annotations.Mapper;

import java.math.BigDecimal;
import java.util.List;

/**
 * 学业成绩Mapper接口
 */
@Mapper
public interface CourseScoreMapper {
    int insert(CourseScore score);
    int deleteById(String scoreId);
    int update(CourseScore score);
    CourseScore selectById(String scoreId);
    List<CourseScore> selectAll();
    List<CourseScore> selectByStudentId(String studentId);
    List<CourseScore> selectByCourseId(String courseId);
    BigDecimal calculateAverageScoreByStudentId(String studentId);
    BigDecimal calculateDegreeCourseAverageScoreByStudentId(String studentId);
}